drop table university;

create table university(
   id number(8) primary key,
   name varchar2(50) unique not null,
   create_time date not null,
   address varchar2(100) not null,
   type varchar2(20) not null,
   leader varchar2(20) not null
);

select * from university;

drop sequence university_seq;

create sequence university_seq;

select university_seq.nextval from dual;

insert into university values(1,'北京大学',to_date('1898-07-03','yyyy-MM-dd'),'北京市海淀区颐和园路5号（主校区）','双一流 985','龚旗煌');
insert into university values(2,'清华大学',to_date('1911-04-01','yyyy-MM-dd'),'北京市海淀区清华园','双一流 985','李路明');
insert into university values(3,'复旦大学',to_date('1905-06-29','yyyy-MM-dd'),'邯郸校区：上海市杨浦区邯郸路220号','双一流 985','金力');
insert into university values(4,'上海交通大学',to_date('1896-01-01','yyyy-MM-dd'),'闵行校区：上海市闵行区东川路800号','双一流 985','丁奎岭');
insert into university values(5,'同济大学',to_date('1907-01-01','yyyy-MM-dd'),'四平路校区（主校区）：上海市杨浦区四平路1239号','双一流 985','郑庆华');
insert into university values(6,'南昌大学',to_date('1921-01-01','yyyy-MM-dd'),'前湖校区：江西省南昌市红谷滩新区学府大道999号（330031）','双一流 211','陈晔光');

commit;